CREATE TABLE [dbo].[Duplicate_Group]
(
[SEQN] [numeric] (18, 0) NOT NULL IDENTITY(1, 1),
[DUP_MATCH_KEY] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MERGE_NOTE] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PREF_MAIL] [int] NULL,
[PREF_BILL] [int] NULL,
[MERGE_IDS] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DELETE_IDS] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[KEEP_IDS] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ADDR_1_NUM] [int] NULL,
[ADDR_2_NUM] [int] NULL,
[ADDR_3_NUM] [int] NULL,
[RETAIN_ID] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PREF_SHIP] [int] NULL
) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [iSEQN] ON [dbo].[Duplicate_Group] ([SEQN]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Duplicate_Group] TO [IMIS]
GRANT SELECT ON  [dbo].[Duplicate_Group] TO [IMIS]
GRANT INSERT ON  [dbo].[Duplicate_Group] TO [IMIS]
GRANT DELETE ON  [dbo].[Duplicate_Group] TO [IMIS]
GRANT UPDATE ON  [dbo].[Duplicate_Group] TO [IMIS]
GO